﻿-- 撤销或者匹配人员班组
create procedure [dbo].[GroupRyInfo_DelAndIns]
@bzid varchar(20) = null,
@sfzh varchar(18)
as
if(@bzid is null)
begin
	delete from Bzry_Info where sfzh=@sfzh
end
else
begin
	insert into Bzry_Info values(@bzid,@sfzh)
end